ALTER TABLE Booking
ADD CONSTRAINT CK_Booking CHECK (BookingNo = NOT NULL);